// Produces: LIMIT 20, 10 (in MySQL. Other databases have slightly different syntax) $this->db->limit(10, 20); $this->db->limit(10); // Produces: LIMIT 10